package com.t.bricks.bussiness.db.entity.userandopenid.base;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;

import java.io.Serializable;
import java.util.Date;

import org.springframework.format.annotation.DateTimeFormat;

import com.t.bricks.annotation.DataInfo;

/**
 * 用户与关注号关联表'UserAndOpenId'表实体类
 * 警告:非数据库字段禁止在此添加,应该创建扩展实体中添加
 */
@ApiModel("用户与关注号关联表UserAndOpenId")
public class UserAndOpenIdBase implements Serializable {

	private static final long serialVersionUID = -1L;// 使用rmi时需修改

	/**
	 * 用户编号(同用户表的用户编号)
	 */
	//[start]
	@DataInfo( sDbName="BricksWeChat", sTableName="UserAndOpenId", sName="sId", sComment="用户编号(同用户表的用户编号)", isDbField=true, sDbFileType="varchar",
		sDefaultData="", isExtra=false, iskey=true, isNull=false,
		iMaxLength=8, isDecimal=false, iIntegralLength=8, iDecimalLength=0, iIndex=0 )
	@ApiModelProperty(value="用户编号(同用户表的用户编号)", example="")
	//[end]
	protected String sId;

	/**
	 * 微信关注号
	 */
	//[start]
	@DataInfo( sDbName="BricksWeChat", sTableName="UserAndOpenId", sName="sOpenId", sComment="微信关注号", isDbField=true, sDbFileType="varchar",
		sDefaultData="", isExtra=false, iskey=false, isNull=true,
		iMaxLength=30, isDecimal=false, iIntegralLength=30, iDecimalLength=0, iIndex=1 )
	@ApiModelProperty(value="微信关注号", example="")
	//[end]
	protected String sOpenId;

	/**
	 * 姓名或工号
	 */
	//[start]
	@DataInfo( sDbName="BricksWeChat", sTableName="UserAndOpenId", sName="sNameOrNo", sComment="姓名或工号", isDbField=true, sDbFileType="varchar",
		sDefaultData="", isExtra=false, iskey=false, isNull=true,
		iMaxLength=64, isDecimal=false, iIntegralLength=64, iDecimalLength=0, iIndex=2 )
	@ApiModelProperty(value="姓名或工号", example="")
	//[end]
	protected String sNameOrNo;

	/**
	 * 密码
	 */
	//[start]
	@DataInfo( sDbName="BricksWeChat", sTableName="UserAndOpenId", sName="sPass", sComment="密码", isDbField=true, sDbFileType="varchar",
		sDefaultData="", isExtra=false, iskey=false, isNull=true,
		iMaxLength=64, isDecimal=false, iIntegralLength=64, iDecimalLength=0, iIndex=3 )
	@ApiModelProperty(value="密码", example="")
	//[end]
	protected String sPass;

	/**
	 * 创建时间
	 */
	@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")//解决表单提交时字符串时间值错误
	//[start]
	@DataInfo( sDbName="BricksWeChat", sTableName="UserAndOpenId", sName="dCreateDate", sComment="创建时间", isDbField=true, sDbFileType="datetime",
		sDefaultData="getdate", isExtra=false, iskey=false, isNull=false,
		iMaxLength=23, isDecimal=true, iIntegralLength=-1, iDecimalLength=-1, iIndex=4 )
	@ApiModelProperty(value="创建时间", example="getdate")
	//[end]
	protected Date dCreateDate;

	/**
	 * 取 用户编号(同用户表的用户编号)
	 * @return String
	 */
	public String getsId() {
		return sId;
	}

	/**
	 * 设置用户编号(同用户表的用户编号)
	 * @param sId
	 */
	public void setsId(String sId) {
		this.sId = sId;
	}

	/**
	 * 取 微信关注号
	 * @return String
	 */
	public String getsOpenId() {
		return sOpenId;
	}

	/**
	 * 设置微信关注号
	 * @param sOpenId
	 */
	public void setsOpenId(String sOpenId) {
		this.sOpenId = sOpenId;
	}

	/**
	 * 取 姓名或工号
	 * @return String
	 */
	public String getsNameOrNo() {
		return sNameOrNo;
	}

	/**
	 * 设置姓名或工号
	 * @param sNameOrNo
	 */
	public void setsNameOrNo(String sNameOrNo) {
		this.sNameOrNo = sNameOrNo;
	}

	/**
	 * 取 密码
	 * @return String
	 */
	public String getsPass() {
		return sPass;
	}

	/**
	 * 设置密码
	 * @param sPass
	 */
	public void setsPass(String sPass) {
		this.sPass = sPass;
	}

	/**
	 * 取 创建时间
	 * @return Date
	 */
	public Date getdCreateDate() {
		return dCreateDate;
	}

	/**
	 * 设置创建时间
	 * @param dCreateDate
	 */
	public void setdCreateDate(Date dCreateDate) {
		this.dCreateDate = dCreateDate;
	}

}
